Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell programming question
After shrinking a number that looks like this 1.76082312808723 down to 1.761
by formatting to 3 decimal places, I need to add a [b] on the end but it bounced back to 1.76082312808723[b]. What do I need to do to the cell so it looks like 1.761[b] or something very very close? I have a huge list of numbers and I'm going to have to replace the "b" in pretty much every number with an "a"or a "c" on most numbers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell programming question
A1 = 1.76082312808723
Try this =ROUND(A1,3)&"[b]" If this post helps click Yes --------------- Jacob Skaria "gmfod" wrote: After shrinking a number that looks like this 1.76082312808723 down to 1.761 by formatting to 3 decimal places, I need to add a [b] on the end but it bounced back to 1.76082312808723[b]. What do I need to do to the cell so it looks like 1.761[b] or something very very close? I have a huge list of numbers and I'm going to have to replace the "b" in pretty much every number with an "a"or a "c" on most numbers. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell programming question
To format the entire column to the same [b]
Format Cells|Custom.. Enter 0.000"[b]" If this post helps click Yes --------------- Jacob Skaria "gmfod" wrote: After shrinking a number that looks like this 1.76082312808723 down to 1.761 by formatting to 3 decimal places, I need to add a [b] on the end but it bounced back to 1.76082312808723[b]. What do I need to do to the cell so it looks like 1.761[b] or something very very close? I have a huge list of numbers and I'm going to have to replace the "b" in pretty much every number with an "a"or a "c" on most numbers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP vs IF programming question | Excel Worksheet Functions | |||
Macro Programming Question | Excel Discussion (Misc queries) | |||
Programming | Excel Discussion (Misc queries) | |||
Programming Cell ID's | Excel Discussion (Misc queries) | |||
CD Programming | Excel Discussion (Misc queries) |