Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text to Columns ???
Hello All
The results of my formulas are time worked in the format of 12.00 or 8.00 etc As the results are centered in the cell, is it possible to have the decimal point in line every time. Obvioulsy if the results are less than 10 hours, they would line up normally. If however, the results are over 10 hours, the whole figure is centered in the cell misaligining the decimal point. If this is possible, please can you explain how. I have tried using Text To Columns, but cannot seem to get it to work. Thanking you in anticipation -- Big Rick |
#2
|
|||
|
|||
Text to Columns ???
Format | Cells | Number | Category: Number | Set decimal places to 2 | OK
Then, Format | Cells | Alignment Tab | Horizontal: Right (Indent) | OK Cheers! Pamela :) "Big Rick" wrote: Hello All The results of my formulas are time worked in the format of 12.00 or 8.00 etc As the results are centered in the cell, is it possible to have the decimal point in line every time. Obvioulsy if the results are less than 10 hours, they would line up normally. If however, the results are over 10 hours, the whole figure is centered in the cell misaligining the decimal point. If this is possible, please can you explain how. I have tried using Text To Columns, but cannot seem to get it to work. Thanking you in anticipation -- Big Rick |
#3
|
|||
|
|||
Text to Columns ???
Rick, You can format the cells as: 0.00____ (four underscores) This will give the appearance that the numbers are centered with the decimals lined up. Switch from Center Align to Right Align. Highlight and right click on the cells you wish to format. Format Cells/Custom and type the above in the Type field. There may be a better way but that seemed to work for me. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=482871 |
#4
|
|||
|
|||
Text to Columns ???
A thousand thanks to you both.
I'm assuming by your answers that Text To Columns is for something completely different !! -- Big Rick "SteveG" wrote: Rick, You can format the cells as: 0.00____ (four underscores) This will give the appearance that the numbers are centered with the decimals lined up. Switch from Center Align to Right Align. Highlight and right click on the cells you wish to format. Format Cells/Custom and type the above in the Type field. There may be a better way but that seemed to work for me. Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=482871 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set text to fit columns? | Excel Discussion (Misc queries) | |||
text to columns: is there a formula? | Excel Worksheet Functions | |||
merging text columns | Excel Discussion (Misc queries) | |||
Text to columns | Excel Discussion (Misc queries) | |||
Text to Columns in excel for delimited files - allow trimming opt. | New Users to Excel |