Probelm with Excel Tools->View->Formulas option and Time format
Probelm with Excel Tools->View->Formulas option and Time format
(OP)
I have a worksheet containing a column with time in HH:MM:SS format and formulas in other columns. I want to print the worksheet with formulas for which i did Options->View->Formulas.
However, doing this changes my HH:MM:SS format to some number that i dont want. when i turn off the view formulas option, the time again changes back to HH:MM:SS format but this doesn't show the formulas in other cells.
So my question is is it possible to view formulas in certain cells but not apply this to other cells in a worksheet?
For example consider this
A B C
1 13:24:55 25 = B1*365+(B1/25)^2
2
3
when i choose view formulas this becomes
1 0.558969907407407 25 = B1*365+(B1/25)^2
However I want A1 to be 13:24:55 but C1 to show the formula
Any suggestions for doing this?
Thanks,
Nodal DOF
However, doing this changes my HH:MM:SS format to some number that i dont want. when i turn off the view formulas option, the time again changes back to HH:MM:SS format but this doesn't show the formulas in other cells.
So my question is is it possible to view formulas in certain cells but not apply this to other cells in a worksheet?
For example consider this
A B C
1 13:24:55 25 = B1*365+(B1/25)^2
2
3
when i choose view formulas this becomes
1 0.558969907407407 25 = B1*365+(B1/25)^2
However I want A1 to be 13:24:55 but C1 to show the formula
Any suggestions for doing this?
Thanks,
Nodal DOF





RE: Probelm with Excel Tools->View->Formulas option and Time format
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Probelm with Excel Tools->View->Formulas option and Time format
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Probelm with Excel Tools->View->Formulas option and Time format
Anyway, since i have only one column with time stamp, i managed to convert them to text using cut and pasting with text import wizard. These files huge about 400mb each and have enormous data in them. So i didn't want to include any macros that may take long times to change.
Nodal DOF
RE: Probelm with Excel Tools->View->Formulas option and Time format
IRStuff was referring to what you have in the C-column, to see the formula in "normal" view, not in "formula" view.
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Probelm with Excel Tools->View->Formulas option and Time format
Thanks,
Nodal DOF
RE: Probelm with Excel Tools->View->Formulas option and Time format
In the following illustration, I formatted cell A5 as TEXT before entering TIME to enable the value to be showed in hh:mm:ss display even when the formulas are being displayed ...
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com