When doing a merge of text (or numbers) (such as a street number cells with
street name cells) the fraction-format numbers are reduced to decimal
numbers. It would be very helpful if number formats could be retained after
a merge, and/or fraction type numbers be allowed to be paste-special as text
and therefore retained after a merge in fraction format. We deal with pole
mounted electrical service addresses that all end in a 1/2. The current
limitation prevents address sorting and we hope this feature can be added
soon.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.
www.microsoft.com/office/comm...et.f unctions
- Apr 21 Sat 2007 20:37
Merge =( formula should retain fraction type numbers after merge.
close
全站熱搜
留言列表
發表留言