Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Frehswater Guildelines row #20
Options
Go to last post Go to first unread
Previous Topic Next Topic
yanti  
#1 Posted : Thursday, April 21, 2016 12:03:28 AM(UTC)
yanti
Rank: Member

Reputation:

Groups: Registered
Posts: 19

Thanks: 1 times

Hi, I wonder if anyone come accross the same issue that i have with excel.

In 3 freshwater guidelines files in setup folder: Environmental Standards\Australia\ANZECC 2000\ row #20 (Hydrogen sulfite) the chemcode cell is formatted as date so it appears as 4/06/7783 instead of 7783-06-4. Everytime i change the format into "general" as others, type the chemcode 7783-06-4 it go back to the date format, so always appears as 4/06/7783.

I also created another excel file blank after that and experience the same problem with row #20.  

Y 
Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
hgetrost  
#2 Posted : Tuesday, April 26, 2016 8:23:11 PM(UTC)
hgetrost
Rank: Administration

Reputation:

Groups: Registered
Posts: 37
Woman

Was thanked: 2 time(s) in 2 post(s)

Set the cell format to “Text” and then Excel won’t change  what you enter.
Back to top
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET